<?php include("koneksi.php");?>
<?php


?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="content-type" content="text/html; charset=utf-8" />
        <title>Metamorphosis Design Free Css Templates</title>
        <meta name="keywords" content="" />
        <meta name="description" content="" />
        <link href="../styles.css" rel="stylesheet" type="text/css" media="screen" />
    </head>
    <body>
        <div id="content">
            <div id="back">
                <!-- header begins -->
                <div id="header">
                    <div id="menu">
                        <ul>
                            <li><a href="#" title="">Home</a></li>
                            <li><a href="#" title="">Blog</a></li>
                            <li><a href="#" title="">Gallery</a></li>
                            <li><a href="#" title="">About</a></li>
                            <li><a href="#" title="">Contact</a></li>
                        </ul>
                    </div>
                </div>
                <!-- header ends -->
                <!-- content begins -->
                <div id="main">
                  <div id="logo">
                      <h1>&nbsp;</h1>
                  </div>
                    <div id="right" >
                        <h4>. 
                         <?php echo "<script language='javascript' src='fushion/JSClass/FusionCharts.js'></script>";
$kon = mysql_connect("localhost", "root", "");
mysql_select_db("travel2");

//path disesuaikan
include("fushion/Code/PHP/Includes/FusionCharts.php");

$xml = "<chart palette='2' useRoundEdges='1' caption='Grafik pemesanan tiket' showBorder='1' formatNumberScale='0' numberPrefix=''>";


//mencari total pemesanan 
$jan = "SELECT * FROM pemesanan WHERE id_jadwal='S01'";
$qjan = mysql_query($jan);
while ($rjan = mysql_fetch_array($qjan))
{
	$tjan = $tjan + $rjan['jumlah'];
}
$xml .= "<set label='SURABAYA' value='".$tjan."'/>";


//mencari total pemesan tiket ke lamongan

$feb = "SELECT * FROM pemesanan WHERE id_jadwal='L02'";
$qfeb = mysql_query($feb);
while ($rfeb = mysql_fetch_array($qfeb))
{
	$tfeb = $tfeb + $rfeb['jumlah'];
}
$xml .= "<set label='LAMONGAN' value='".$tfeb."'/>";

//mencari total pendaftaran bulan maret
$mar = "SELECT * FROM pemesanan WHERE id_jadwal='K03'";
$qmar = mysql_query($mar);
while ($rmar = mysql_fetch_array($qmar))
{
	$tmar = $tmar + $rmar['jumlah'];
}
$xml .= "<set label='KEDIRI' value='".$tmar."'/>";




$xml .= "</chart>";

//path disesuaikan
echo renderChart("fushion/Charts/Column3D.swf", "", $xml, "Grafik", 550, 550, false, false); ?>
                        </h4>
                    </div>
                    <div id="left">
                        <h3>Categories</h3>
                        <div class="categories">
                            <ul>

                                <li><a href="../pemesanan/input_pemesanan.php">pemesanan</a></li>
                                <li><a href="../jenis_bis/jenis_bis.php">jenis_bis</a></li>
                                <li><a href="ketersediaan.php">ketersediaan</a></li>
                                <li><a href="#">tips bepergian</a></li>
                                <li><a href="#">info penumpang</a></li>
                                

                            </ul>
                        </div>

                        <h3>Our Partners</h3>

                        <div class="partners">
                            <ul>

                                <li><a href="#">bajo express</a></li>
                                <li><a href="#">guide search</a></li>
                               

                            </ul>
                        </div>
                    </div>
                    <div style="clear: both;"></div>
                    <div id="mainbot"></div>

                    <!--content ends -->
                    <!--footer begins -->
                </div>
                
                <div id="footer">
                     <p>Copyright  2011.endang ayu ningsih (08560024)|chilman chakiki (08560404)| <a href="http://validator.w3.org/check/referer" title="This page validates as XHTML 1.0 Transitional"><abbr title="eXtensible HyperText Markup Language">XHTML</abbr></a> | <a href="http://jigsaw.w3.org/css-validator/check/referer" title="This page validates as CSS"><abbr title="Cascading Style Sheets">CSS</abbr></a></p> 
	<p>Design by ayu and caki forDBT task</p>
                </div>
                <div style="clear: both"></div>
            </div>

        </div>
        <!-- footer ends-->
    </body>
</html>